package com.oracle.mapper;

import com.oracle.pojo.Category;
import com.oracle.pojo.CategoryExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface CategoryMapper {
    long countByExample(CategoryExample example);

    int deleteByExample(CategoryExample example);

    int deleteByPrimaryKey(Integer cid);

    int insert(Category record);

    int insertSelective(Category record);

    List<Category> selectByExample(CategoryExample example);

    Category selectByPrimaryKey(Integer cid);

    int updateByExampleSelective(@Param("record") Category record, @Param("example") CategoryExample example);

    int updateByExample(@Param("record") Category record, @Param("example") CategoryExample example);

    int updateByPrimaryKeySelective(Category record);

    int updateByPrimaryKey(Category record);

    @Select("select cname from category where cid = #{cid}")
    String selectByCid(Integer cid);

    @Select("select stated from category where cid = #{cid}")
    String selectStatedByCid(Integer cid);

    @Select("select * from category")
    List<Category> selectCategorys();

}